Tabela ContractServicesCosts

Definicja tabeli ContractServicesCosts

Name

ContractServicesCosts

Code

ContractServicesCosts

Comment

 


Lista kolumn tabeli ContractServicesCosts

Name

Code

EpisodeID

EpisodeID

ServID

ServID

PerfServiceID

PerfServiceID

ResourceID

ResourceID

ContractServID

ContractServID

ContractServicePerfID

ContractServicePerfID

EpisodeDaysPrice

EpisodeDaysPrice

Price

Price

UnitsCount

UnitsCount

DietDays

DietDays

DietPrice

DietPrice

SumDietPrice

SumDietPrice

PerfResUnitsCount

PerfResUnitsCount

CS_UnitsCount

CS_UnitsCount

CSPoint_Price

CSPoint_Price

ContractData_Price

ContractData_Price

SummaryCS_Price

SummaryCS_Price

EpisodeStopDT

EpisodeStopDT


Kolumna EpisodeID tabeli ContractServicesCosts

Definicja kolumny EpisodeID tabeli ContractServicesCosts

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli ContractServicesCosts

Definicja kolumny ServID tabeli ContractServicesCosts

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfServiceID tabeli ContractServicesCosts

Definicja kolumny PerfServiceID tabeli ContractServicesCosts

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceID tabeli ContractServicesCosts

Definicja kolumny ResourceID tabeli ContractServicesCosts

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractServID tabeli ContractServicesCosts

Definicja kolumny ContractServID tabeli ContractServicesCosts

Name

ContractServID

Code

ContractServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractServicePerfID tabeli ContractServicesCosts

Definicja kolumny ContractServicePerfID tabeli ContractServicesCosts

Name

ContractServicePerfID

Code

ContractServicePerfID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeDaysPrice tabeli ContractServicesCosts

Definicja kolumny EpisodeDaysPrice tabeli ContractServicesCosts

Name

EpisodeDaysPrice

Code

EpisodeDaysPrice

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna Price tabeli ContractServicesCosts

Definicja kolumny Price tabeli ContractServicesCosts

Name

Price

Code

Price

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli ContractServicesCosts

Definicja kolumny UnitsCount tabeli ContractServicesCosts

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(12,6)

Mandatory

No

Comment

 


Kolumna DietDays tabeli ContractServicesCosts

Definicja kolumny DietDays tabeli ContractServicesCosts

Name

DietDays

Code

DietDays

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DietPrice tabeli ContractServicesCosts

Definicja kolumny DietPrice tabeli ContractServicesCosts

Name

DietPrice

Code

DietPrice

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna SumDietPrice tabeli ContractServicesCosts

Definicja kolumny SumDietPrice tabeli ContractServicesCosts

Name

SumDietPrice

Code

SumDietPrice

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna PerfResUnitsCount tabeli ContractServicesCosts

Definicja kolumny PerfResUnitsCount tabeli ContractServicesCosts

Name

PerfResUnitsCount

Code

PerfResUnitsCount

Data Type

BINARY_DOUBLE

Mandatory

No

Comment

 


Kolumna CS_UnitsCount tabeli ContractServicesCosts

Definicja kolumny CS_UnitsCount tabeli ContractServicesCosts

Name

CS_UnitsCount

Code

CS_UnitsCount

Data Type

BINARY_DOUBLE

Mandatory

No

Comment

 


Kolumna CSPoint_Price tabeli ContractServicesCosts

Definicja kolumny CSPoint_Price tabeli ContractServicesCosts

Name

CSPoint_Price

Code

CSPoint_Price

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna ContractData_Price tabeli ContractServicesCosts

Definicja kolumny ContractData_Price tabeli ContractServicesCosts

Name

ContractData_Price

Code

ContractData_Price

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna SummaryCS_Price tabeli ContractServicesCosts

Definicja kolumny SummaryCS_Price tabeli ContractServicesCosts

Name

SummaryCS_Price

Code

SummaryCS_Price

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna EpisodeStopDT tabeli ContractServicesCosts

Definicja kolumny EpisodeStopDT tabeli ContractServicesCosts

Name

EpisodeStopDT

Code

EpisodeStopDT

Data Type

DATE

Mandatory

No

Comment